<?php
/*10.8.8.1      2017-07-04 15:49:54
http://www.yu180.com/index.php/ask/tag      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 15:55:25
http://www.yu180.com/index.php/ask/tag      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 17:40:11
http://www.yu180.com/index.php/ask/tag      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 17:48:17
http://www.yu180.com/index.php/ask/tag      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 17:48:32
http://www.yu180.com/index.php/ask/tag      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 17:48:56
http://www.yu180.com/index.php/ask/tag      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 18:47:12
http://www.yu180.com/index.php/group/my      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 21:12:39
http://www.yu180.com/index.php/site      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 21:12:48
http://www.yu180.com/index.php/site      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 21:16:05
http://www.yu180.com/index.php/site      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 21:18:20
http://www.yu180.com/index.php/site      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 21:25:41
http://www.yu180.com/index.php/msg      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 21:27:13
http://www.yu180.com/index.php/msg      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 21:28:17
http://www.yu180.com/index.php/msg      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 21:29:39
http://www.yu180.com/index.php/site/index/doadd      
Array
(
    [csrf] => 30690687566e86a28e8690b88adae05b
    [title] => mysql sql_mode 之 NO_ENGINE_SUBSTITUTION
    [content] => <p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	知识储备：
</p>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	　　1、mysql 有众多的存储引擎，然而只有一个默认的存储引擎，通常来说它是innodb
</p>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	　　2、mysql 可以通过sql_mode 来控制mysql 数据库的行为，今天我们要讲的就是no_engine_substitution
</p>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	　　3、no_engine_subtitution的作用：mysql 在create table 时可以指定engine子句；这个engine子句用于指定表的存储引擎，那么问题就来了。
</p>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	　　　 &nbsp;如果我把引擎指定成一个并不存在的引擎！这个时候mysql可以有两种行为供选择 1、直接报错；2、把表的存储引擎替换成innodb
</p>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	&nbsp;
</p>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	例子：
</p>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	　　1、环境检查(查看mysql所支持的存储引擎，sql_mode模式)
</p>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	　　001：存储引擎，由下图可以看出在这个mysql上不支持federated 引擎
</p>
<div class="cnblogs_code" style="background-color:#F5F5F5;border:1px solid #CCCCCC;padding:5px;margin:5px 0px;font-family:&quot;">
	<div class="cnblogs_code_toolbar">
		<span style="line-height:1.5 !important;"><a><img src="http://common.cnblogs.com/images/copycode.gif" alt="复制代码" /></a></span>
	</div>
<pre>mysql<span style="color:#808080;line-height:1.5 !important;">&gt;</span><span style="line-height:1.5 !important;"> show engines; </span><span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">------------------+---------+----------------------------------------------------------------+--------------+------+------------+</span> <span style="color:#808080;line-height:1.5 !important;">|</span> Engine <span style="color:#808080;line-height:1.5 !important;">|</span> Support <span style="color:#808080;line-height:1.5 !important;">|</span> Comment <span style="color:#808080;line-height:1.5 !important;">|</span> Transactions <span style="color:#808080;line-height:1.5 !important;">|</span> XA <span style="color:#808080;line-height:1.5 !important;">|</span> Savepoints <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">------------------+---------+----------------------------------------------------------------+--------------+------+------------+</span> <span style="color:#808080;line-height:1.5 !important;">|</span> MyISAM <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> MyISAM storage engine <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> CSV <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> CSV storage engine <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> MRG_MYISAM <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> Collection <span style="color:#0000FF;line-height:1.5 !important;">of</span> identical MyISAM tables <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> BLACKHOLE <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">/</span>dev<span style="color:#808080;line-height:1.5 !important;">/</span><span style="color:#0000FF;line-height:1.5 !important;">null</span> storage engine (anything you write <span style="color:#0000FF;line-height:1.5 !important;">to</span> it disappears) <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> MEMORY <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> Hash based, stored <span style="color:#808080;line-height:1.5 !important;">in</span> memory, useful <span style="color:#0000FF;line-height:1.5 !important;">for</span> <span style="color:#0000FF;line-height:1.5 !important;">temporary</span> tables <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> PERFORMANCE_SCHEMA <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> Performance <span style="color:#0000FF;line-height:1.5 !important;">Schema</span> <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> ARCHIVE <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> Archive storage engine <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> InnoDB <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#0000FF;line-height:1.5 !important;">DEFAULT</span> <span style="color:#808080;line-height:1.5 !important;">|</span> Supports transactions, row<span style="color:#808080;line-height:1.5 !important;">-</span><span style="color:#0000FF;line-height:1.5 !important;">level</span> locking, <span style="color:#808080;line-height:1.5 !important;">and</span> <span style="color:#0000FF;line-height:1.5 !important;">foreign</span> keys <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> FEDERATED <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> Federated MySQL storage engine <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#0000FF;line-height:1.5 !important;">NULL</span> <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#0000FF;line-height:1.5 !important;">NULL</span> <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#0000FF;line-height:1.5 !important;">NULL</span> <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">------------------+---------+----------------------------------------------------------------+--------------+------+------------+</span> <span style="color:#800000;font-weight:bold;line-height:1.5 !important;">9</span> rows <span style="color:#808080;line-height:1.5 !important;">in</span> <span style="color:#0000FF;line-height:1.5 !important;">set</span> (<span style="color:#800000;font-weight:bold;line-height:1.5 !important;">0.00</span> sec)</pre>
	<div class="cnblogs_code_toolbar">
		<span style="line-height:1.5 !important;"><a><img src="http://common.cnblogs.com/images/copycode.gif" alt="复制代码" /></a></span>
	</div>
</div>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	<span style="line-height:1.5;">　　002：sql_mode</span>
</p>
<div class="cnblogs_code" style="background-color:#F5F5F5;border:1px solid #CCCCCC;padding:5px;margin:5px 0px;font-family:&quot;">
	<div class="cnblogs_code_toolbar">
		<span style="line-height:1.5 !important;"><a><img src="http://common.cnblogs.com/images/copycode.gif" alt="复制代码" /></a></span>
	</div>
<pre>mysql<span style="color:#808080;line-height:1.5 !important;">&gt;</span> show variables <span style="color:#808080;line-height:1.5 !important;">like</span> <span style="color:#FF0000;line-height:1.5 !important;">'</span><span style="color:#FF0000;line-height:1.5 !important;">sql_mode</span><span style="color:#FF0000;line-height:1.5 !important;">'</span><span style="line-height:1.5 !important;">; </span><span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">-------------+---------------------+</span> <span style="color:#808080;line-height:1.5 !important;">|</span> Variable_name <span style="color:#808080;line-height:1.5 !important;">|</span> Value <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">-------------+---------------------+</span> <span style="color:#808080;line-height:1.5 !important;">|</span> sql_mode <span style="color:#808080;line-height:1.5 !important;">|</span> STRICT_TRANS_TABLES <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">-------------+---------------------+</span> <span style="color:#800000;font-weight:bold;line-height:1.5 !important;">1</span> row <span style="color:#808080;line-height:1.5 !important;">in</span> <span style="color:#0000FF;line-height:1.5 !important;">set</span> (<span style="color:#800000;font-weight:bold;line-height:1.5 !important;">0.00</span> sec)</pre>
	<div class="cnblogs_code_toolbar">
		<span style="line-height:1.5 !important;"><a><img src="http://common.cnblogs.com/images/copycode.gif" alt="复制代码" /></a></span>
	</div>
</div>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	　　003：测试
</p>
<div class="cnblogs_code" style="background-color:#F5F5F5;border:1px solid #CCCCCC;padding:5px;margin:5px 0px;font-family:&quot;">
	<div class="cnblogs_code_toolbar">
		<span style="line-height:1.5 !important;"><a><img src="http://common.cnblogs.com/images/copycode.gif" alt="复制代码" /></a></span>
	</div>
<pre>mysql<span style="color:#808080;line-height:1.5 !important;">&gt;</span> <span style="color:#0000FF;line-height:1.5 !important;">create</span> <span style="color:#0000FF;line-height:1.5 !important;">table</span> t(x <span style="color:#0000FF;line-height:1.5 !important;">int</span>) engine<span style="color:#808080;line-height:1.5 !important;">=</span><span style="line-height:1.5 !important;">federated;
Query OK, </span><span style="color:#800000;font-weight:bold;line-height:1.5 !important;">0</span> rows affected, <span style="color:#800000;font-weight:bold;line-height:1.5 !important;">2</span> warnings (<span style="color:#800000;font-weight:bold;line-height:1.5 !important;">0.11</span><span style="line-height:1.5 !important;"> sec)

mysql</span><span style="color:#808080;line-height:1.5 !important;">&gt;</span> show <span style="color:#0000FF;line-height:1.5 !important;">create</span> <span style="color:#0000FF;line-height:1.5 !important;">table</span><span style="line-height:1.5 !important;"> t; </span><span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">-----+--------------------------------------------------------------------------------------+</span> <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#0000FF;line-height:1.5 !important;">Table</span> <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#0000FF;line-height:1.5 !important;">Create</span> <span style="color:#0000FF;line-height:1.5 !important;">Table</span> <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">-----+--------------------------------------------------------------------------------------+</span> <span style="color:#808080;line-height:1.5 !important;">|</span> t <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#0000FF;line-height:1.5 !important;">CREATE</span> <span style="color:#0000FF;line-height:1.5 !important;">TABLE</span><span style="line-height:1.5 !important;"> `t` (
  `x` </span><span style="color:#0000FF;line-height:1.5 !important;">int</span>(<span style="color:#800000;font-weight:bold;line-height:1.5 !important;">11</span>) <span style="color:#0000FF;line-height:1.5 !important;">DEFAULT</span> <span style="color:#0000FF;line-height:1.5 !important;">NULL</span><span style="line-height:1.5 !important;"> ) ENGINE</span><span style="color:#808080;line-height:1.5 !important;">=</span>InnoDB <span style="color:#0000FF;line-height:1.5 !important;">DEFAULT</span> CHARSET<span style="color:#808080;line-height:1.5 !important;">=</span>latin1 <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">-----+--------------------------------------------------------------------------------------+</span> <span style="color:#800000;font-weight:bold;line-height:1.5 !important;">1</span> row <span style="color:#808080;line-height:1.5 !important;">in</span> <span style="color:#0000FF;line-height:1.5 !important;">set</span> (<span style="color:#800000;font-weight:bold;line-height:1.5 !important;">0.00</span><span style="line-height:1.5 !important;"> sec)

mysql</span><span style="color:#808080;line-height:1.5 !important;">&gt;</span> </pre>
	<div class="cnblogs_code_toolbar">
		<span style="line-height:1.5 !important;"><a><img src="http://common.cnblogs.com/images/copycode.gif" alt="复制代码" /></a></span>
	</div>
</div>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	结论001：<span style="color:#FF0000;">在sql_mode中不包涵no_engine_subtitution 且create table 中engine子句指定的存储引擎不被支持时，mysql会把表的引擎改为innodb</span>。
</p>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	&nbsp;
</p>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	例子：
</p>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	　　在sql_mode包涵有no_engine_subtitution时
</p>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	　　引擎支持情况：
</p>
<div class="cnblogs_code" style="background-color:#F5F5F5;border:1px solid #CCCCCC;padding:5px;margin:5px 0px;font-family:&quot;">
	<div class="cnblogs_code_toolbar">
		<span style="line-height:1.5 !important;"><a><img src="http://common.cnblogs.com/images/copycode.gif" alt="复制代码" /></a></span>
	</div>
<pre>mysql<span style="color:#808080;line-height:1.5 !important;">&gt;</span><span style="line-height:1.5 !important;"> show engines; </span><span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">------------------+---------+----------------------------------------------------------------+--------------+------+------------+</span> <span style="color:#808080;line-height:1.5 !important;">|</span> Engine <span style="color:#808080;line-height:1.5 !important;">|</span> Support <span style="color:#808080;line-height:1.5 !important;">|</span> Comment <span style="color:#808080;line-height:1.5 !important;">|</span> Transactions <span style="color:#808080;line-height:1.5 !important;">|</span> XA <span style="color:#808080;line-height:1.5 !important;">|</span> Savepoints <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">------------------+---------+----------------------------------------------------------------+--------------+------+------------+</span> <span style="color:#808080;line-height:1.5 !important;">|</span> MyISAM <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> MyISAM storage engine <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> CSV <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> CSV storage engine <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> MRG_MYISAM <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> Collection <span style="color:#0000FF;line-height:1.5 !important;">of</span> identical MyISAM tables <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> BLACKHOLE <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">/</span>dev<span style="color:#808080;line-height:1.5 !important;">/</span><span style="color:#0000FF;line-height:1.5 !important;">null</span> storage engine (anything you write <span style="color:#0000FF;line-height:1.5 !important;">to</span> it disappears) <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> MEMORY <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> Hash based, stored <span style="color:#808080;line-height:1.5 !important;">in</span> memory, useful <span style="color:#0000FF;line-height:1.5 !important;">for</span> <span style="color:#0000FF;line-height:1.5 !important;">temporary</span> tables <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> PERFORMANCE_SCHEMA <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> Performance <span style="color:#0000FF;line-height:1.5 !important;">Schema</span> <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> ARCHIVE <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> Archive storage engine <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> InnoDB <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#0000FF;line-height:1.5 !important;">DEFAULT</span> <span style="color:#808080;line-height:1.5 !important;">|</span> Supports transactions, row<span style="color:#808080;line-height:1.5 !important;">-</span><span style="color:#0000FF;line-height:1.5 !important;">level</span> locking, <span style="color:#808080;line-height:1.5 !important;">and</span> <span style="color:#0000FF;line-height:1.5 !important;">foreign</span> keys <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> YES <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">|</span> FEDERATED <span style="color:#808080;line-height:1.5 !important;">|</span> NO <span style="color:#808080;line-height:1.5 !important;">|</span> Federated MySQL storage engine <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#0000FF;line-height:1.5 !important;">NULL</span> <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#0000FF;line-height:1.5 !important;">NULL</span> <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#0000FF;line-height:1.5 !important;">NULL</span> <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">------------------+---------+----------------------------------------------------------------+--------------+------+------------+</span> <span style="color:#800000;font-weight:bold;line-height:1.5 !important;">9</span> rows <span style="color:#808080;line-height:1.5 !important;">in</span> <span style="color:#0000FF;line-height:1.5 !important;">set</span> (<span style="color:#800000;font-weight:bold;line-height:1.5 !important;">0.00</span> sec)</pre>
	<div class="cnblogs_code_toolbar">
		<span style="line-height:1.5 !important;"><a><img src="http://common.cnblogs.com/images/copycode.gif" alt="复制代码" /></a></span>
	</div>
</div>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	　　sql_mode情况：
</p>
<div class="cnblogs_code" style="background-color:#F5F5F5;border:1px solid #CCCCCC;padding:5px;margin:5px 0px;font-family:&quot;">
	<div class="cnblogs_code_toolbar">
		<span style="line-height:1.5 !important;"><a><img src="http://common.cnblogs.com/images/copycode.gif" alt="复制代码" /></a></span>
	</div>
<pre>mysql<span style="color:#808080;line-height:1.5 !important;">&gt;</span> show variables <span style="color:#808080;line-height:1.5 !important;">like</span> <span style="color:#FF0000;line-height:1.5 !important;">'</span><span style="color:#FF0000;line-height:1.5 !important;">sql_mode</span><span style="color:#FF0000;line-height:1.5 !important;">'</span><span style="line-height:1.5 !important;">; </span><span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">-------------+--------------------------------------------+</span> <span style="color:#808080;line-height:1.5 !important;">|</span> Variable_name <span style="color:#808080;line-height:1.5 !important;">|</span> Value <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">-------------+--------------------------------------------+</span> <span style="color:#808080;line-height:1.5 !important;">|</span> sql_mode <span style="color:#808080;line-height:1.5 !important;">|</span> STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION <span style="color:#808080;line-height:1.5 !important;">|</span> <span style="color:#808080;line-height:1.5 !important;">+</span><span style="color:#008080;line-height:1.5 !important;">--</span><span style="color:#008080;line-height:1.5 !important;">-------------+--------------------------------------------+</span> <span style="color:#800000;font-weight:bold;line-height:1.5 !important;">1</span> row <span style="color:#808080;line-height:1.5 !important;">in</span> <span style="color:#0000FF;line-height:1.5 !important;">set</span> (<span style="color:#800000;font-weight:bold;line-height:1.5 !important;">0.00</span> sec)</pre>
	<div class="cnblogs_code_toolbar">
		<span style="line-height:1.5 !important;"><a><img src="http://common.cnblogs.com/images/copycode.gif" alt="复制代码" /></a></span>
	</div>
</div>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	　　测试：
</p>
<div class="cnblogs_code" style="background-color:#F5F5F5;border:1px solid #CCCCCC;padding:5px;margin:5px 0px;font-family:&quot;">
<pre>mysql<span style="color:#808080;line-height:1.5 !important;">&gt;</span> <span style="color:#0000FF;line-height:1.5 !important;">create</span> <span style="color:#0000FF;line-height:1.5 !important;">table</span> t2(x <span style="color:#0000FF;line-height:1.5 !important;">int</span>) engine<span style="color:#808080;line-height:1.5 !important;">=</span><span style="line-height:1.5 !important;">federated;
ERROR </span><span style="color:#800000;font-weight:bold;line-height:1.5 !important;">1286</span> (<span style="color:#800000;font-weight:bold;line-height:1.5 !important;">42000</span>): Unknown storage engine <span style="color:#FF0000;line-height:1.5 !important;">'</span><span style="color:#FF0000;line-height:1.5 !important;">federated</span><span style="color:#FF0000;line-height:1.5 !important;">'</span></pre>
</div>
<p style="font-family:Verdana, Arial, Helvetica, sans-serif;font-size:14px;background-color:#FFFFFF;">
	结论002：<span style="color:#FF0000;">当sql_mode中包涵no_engine_subtitution时，如果create table 时指定的engine项不被支持，这个时候mysql会支持报错。</span>
</p>
    [captcha] => empe
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 21:41:00
http://www.yu180.com/index.php/group/my      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 21:41:47
http://www.yu180.com/index.php/group/my/2      
Array
(
)
      
出错啦!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 21:54:57
http://www.yu180.com/index.php/index.php/install/index/index      
Array
(
)
      
页面不存在!
---------------------------------------------------
*/
/*10.8.8.1      2017-07-04 21:55:08
http://www.yu180.com/index.php/index.php/install/index/index      
Array
(
)
      
页面不存在!
---------------------------------------------------
*/
